package org.liuyuantao.mybatis.mapper;

import org.liuyuantao.mybatis.po.OrderCustom;
import org.liuyuantao.mybatis.po.Orders;
import org.liuyuantao.mybatis.po.User;

import java.util.List;


public interface OrdersMapperCustom {
    // 一对一查询，查询订单关联查询用户，使用resultType
    public List<OrderCustom> findOrderUserList() throws Exception;

    // 一对一查询，使用resultMap
    public List<Orders> findOrderUserListResultMap() throws Exception;

    //一对一查询，延迟加载
    public List<Orders> findOrderUserListLazyLoading() throws Exception;

    // 一对多查询，使用resultMap
    public List<Orders> findOrderAndOrderDetails() throws Exception;

    // 一对多查询，使用resultMap
    public List<User> findUserOrderDetail() throws Exception;
}
